<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.20"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>libxlsxwriter: lxw_conditional_format Struct Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="customdoxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">libxlsxwriter
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.20 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

</div><!-- top -->
<div class="header">
  <div class="summary">
<a href="#pub-attribs">Data Fields</a>  </div>
  <div class="headertitle">
<div class="title">lxw_conditional_format Struct Reference</div>  </div>
</div><!--header-->
<div class="contents">

<p>Worksheet conditional formatting options.  
 <a href="structlxw__conditional__format.html#details">More...</a></p>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock"><p>The fields/options in the the <a class="el" href="structlxw__conditional__format.html" title="Worksheet conditional formatting options.">lxw_conditional_format</a> are used to define a worksheet conditional format. It is used in conjunction with <code>worksheet_conditional_format()</code>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format1_8c-example.html#_a10">conditional_format1.c</a>, and <a class="el" href="conditional_format2_8c-example.html#_a2">conditional_format2.c</a>.</dd>
</dl>
</div><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-attribs"></a>
Data Fields</h2></td></tr>
<tr class="memitem:ad184e6a2d11120c042c22e181b15a348"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ad184e6a2d11120c042c22e181b15a348">type</a></td></tr>
<tr class="separator:ad184e6a2d11120c042c22e181b15a348"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a06fc7b5549574bac769cf93ae7180e3f"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a06fc7b5549574bac769cf93ae7180e3f">criteria</a></td></tr>
<tr class="separator:a06fc7b5549574bac769cf93ae7180e3f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa11acc4f64d532fafc7cda9a98dc1fc9"><td class="memItemLeft" align="right" valign="top">double&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#aa11acc4f64d532fafc7cda9a98dc1fc9">value</a></td></tr>
<tr class="separator:aa11acc4f64d532fafc7cda9a98dc1fc9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad09997b3e8aa12dba5617739c8839e7d"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ad09997b3e8aa12dba5617739c8839e7d">value_string</a></td></tr>
<tr class="separator:ad09997b3e8aa12dba5617739c8839e7d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3d3ca3432272ee4d5172349ae030dfcc"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structlxw__format.html">lxw_format</a> *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a3d3ca3432272ee4d5172349ae030dfcc">format</a></td></tr>
<tr class="separator:a3d3ca3432272ee4d5172349ae030dfcc"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af8b4013a50ba2a58fa009dc22dcb9db8"><td class="memItemLeft" align="right" valign="top">double&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#af8b4013a50ba2a58fa009dc22dcb9db8">min_value</a></td></tr>
<tr class="separator:af8b4013a50ba2a58fa009dc22dcb9db8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a171ca24363807d7071d7044f9586a481"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a171ca24363807d7071d7044f9586a481">min_value_string</a></td></tr>
<tr class="separator:a171ca24363807d7071d7044f9586a481"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aedf2517dee1d1aac4e963dc315879b62"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#aedf2517dee1d1aac4e963dc315879b62">min_rule_type</a></td></tr>
<tr class="separator:aedf2517dee1d1aac4e963dc315879b62"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab800fddf49071afb1ce9f020d44b2b3c"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ab800fddf49071afb1ce9f020d44b2b3c">min_color</a></td></tr>
<tr class="separator:ab800fddf49071afb1ce9f020d44b2b3c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae05120a2be801d037bed0abe8a71de40"><td class="memItemLeft" align="right" valign="top">double&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ae05120a2be801d037bed0abe8a71de40">mid_value</a></td></tr>
<tr class="separator:ae05120a2be801d037bed0abe8a71de40"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad0b7b11e7e88aeb9b92c24b1e7901cb8"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ad0b7b11e7e88aeb9b92c24b1e7901cb8">mid_value_string</a></td></tr>
<tr class="separator:ad0b7b11e7e88aeb9b92c24b1e7901cb8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0b3dd44b45e5cc5c49be1817aa873b04"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a0b3dd44b45e5cc5c49be1817aa873b04">mid_rule_type</a></td></tr>
<tr class="separator:a0b3dd44b45e5cc5c49be1817aa873b04"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af81689ba9f4c8a89b1e32f62054136ad"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#af81689ba9f4c8a89b1e32f62054136ad">mid_color</a></td></tr>
<tr class="separator:af81689ba9f4c8a89b1e32f62054136ad"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a18ce2238c9d2c51b79e9c9206c892a2c"><td class="memItemLeft" align="right" valign="top">double&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a18ce2238c9d2c51b79e9c9206c892a2c">max_value</a></td></tr>
<tr class="separator:a18ce2238c9d2c51b79e9c9206c892a2c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ade7850adeac45fc0ebc95b31bed939cf"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ade7850adeac45fc0ebc95b31bed939cf">max_value_string</a></td></tr>
<tr class="separator:ade7850adeac45fc0ebc95b31bed939cf"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af473b5134c8851ad6e8e32b8e96e125a"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#af473b5134c8851ad6e8e32b8e96e125a">max_rule_type</a></td></tr>
<tr class="separator:af473b5134c8851ad6e8e32b8e96e125a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6d4a5eb20238f46f2fc594f1a5e1bc33"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a6d4a5eb20238f46f2fc594f1a5e1bc33">max_color</a></td></tr>
<tr class="separator:a6d4a5eb20238f46f2fc594f1a5e1bc33"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad2dc53f2c1668c926452a27b41fcb640"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ad2dc53f2c1668c926452a27b41fcb640">bar_color</a></td></tr>
<tr class="separator:ad2dc53f2c1668c926452a27b41fcb640"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a208a4c91723db5794041d1b488992619"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a208a4c91723db5794041d1b488992619">bar_only</a></td></tr>
<tr class="separator:a208a4c91723db5794041d1b488992619"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a407c47249bff85bdc92f25502daea813"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a407c47249bff85bdc92f25502daea813">data_bar_2010</a></td></tr>
<tr class="separator:a407c47249bff85bdc92f25502daea813"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a7f3f95a74f02ab316c38db46b0b8499c"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a7f3f95a74f02ab316c38db46b0b8499c">bar_solid</a></td></tr>
<tr class="separator:a7f3f95a74f02ab316c38db46b0b8499c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1f9a9a9a1840d78f6ac697365bb957bf"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a1f9a9a9a1840d78f6ac697365bb957bf">bar_negative_color</a></td></tr>
<tr class="separator:a1f9a9a9a1840d78f6ac697365bb957bf"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:afbf602ea1d3d6df8591976c9c62a7cf9"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#afbf602ea1d3d6df8591976c9c62a7cf9">bar_border_color</a></td></tr>
<tr class="separator:afbf602ea1d3d6df8591976c9c62a7cf9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1ee05313ff7e57c5ac48aca6b0ed3034"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a1ee05313ff7e57c5ac48aca6b0ed3034">bar_negative_border_color</a></td></tr>
<tr class="separator:a1ee05313ff7e57c5ac48aca6b0ed3034"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa78aa5551b20f92d1d80efc00939005c"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#aa78aa5551b20f92d1d80efc00939005c">bar_negative_color_same</a></td></tr>
<tr class="separator:aa78aa5551b20f92d1d80efc00939005c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad053eb830063113c9893c04a0a7b4ef4"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ad053eb830063113c9893c04a0a7b4ef4">bar_negative_border_color_same</a></td></tr>
<tr class="separator:ad053eb830063113c9893c04a0a7b4ef4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:addb516a5e4872c4dfaafe1718dc9a8a9"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#addb516a5e4872c4dfaafe1718dc9a8a9">bar_no_border</a></td></tr>
<tr class="separator:addb516a5e4872c4dfaafe1718dc9a8a9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8b249e7f9e9f4849013e1879d9629eb1"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a8b249e7f9e9f4849013e1879d9629eb1">bar_direction</a></td></tr>
<tr class="separator:a8b249e7f9e9f4849013e1879d9629eb1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a4082b4c5f5d63cc22b2aca1e0f482648"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a4082b4c5f5d63cc22b2aca1e0f482648">bar_axis_position</a></td></tr>
<tr class="separator:a4082b4c5f5d63cc22b2aca1e0f482648"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:acabc9974b1c8ae033909b3e634016e57"><td class="memItemLeft" align="right" valign="top"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#acabc9974b1c8ae033909b3e634016e57">bar_axis_color</a></td></tr>
<tr class="separator:acabc9974b1c8ae033909b3e634016e57"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0cf9351bf7eb8bdfddb988ca9c24f308"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a0cf9351bf7eb8bdfddb988ca9c24f308">icon_style</a></td></tr>
<tr class="separator:a0cf9351bf7eb8bdfddb988ca9c24f308"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aac7b01a937ca3203030ddbe8d34d54de"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#aac7b01a937ca3203030ddbe8d34d54de">reverse_icons</a></td></tr>
<tr class="separator:aac7b01a937ca3203030ddbe8d34d54de"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae7dce71531b0b265f88577b008368d96"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#ae7dce71531b0b265f88577b008368d96">icons_only</a></td></tr>
<tr class="separator:ae7dce71531b0b265f88577b008368d96"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3fed811ec39cfda41a3c4db3135f1841"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a3fed811ec39cfda41a3c4db3135f1841">multi_range</a></td></tr>
<tr class="separator:a3fed811ec39cfda41a3c4db3135f1841"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a18603b91945774c02a3aeae8e133bbc6"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__conditional__format.html#a18603b91945774c02a3aeae8e133bbc6">stop_if_true</a></td></tr>
<tr class="separator:a18603b91945774c02a3aeae8e133bbc6"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<h2 class="groupheader">Field Documentation</h2>
<a id="ad184e6a2d11120c042c22e181b15a348"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad184e6a2d11120c042c22e181b15a348">&#9670;&nbsp;</a></span>type</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::type</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The type of conditional format such as <a class="el" href="worksheet_8h.html#affdc3f401f3ee241fad5d651628ac92dac9180feb375f5d9302d80467398a0c6e">LXW_CONDITIONAL_TYPE_CELL</a> or <a class="el" href="worksheet_8h.html#affdc3f401f3ee241fad5d651628ac92dae0c88a53343690c1f43385b466dfe45e">LXW_CONDITIONAL_DATA_BAR</a>. Should be a <a class="el" href="worksheet_8h.html#affdc3f401f3ee241fad5d651628ac92d" title="Type definitions for conditional formats.">lxw_conditional_format_types</a> value. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format1_8c-example.html#a11">conditional_format1.c</a>, and <a class="el" href="conditional_format2_8c-example.html#a12">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a06fc7b5549574bac769cf93ae7180e3f"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a06fc7b5549574bac769cf93ae7180e3f">&#9670;&nbsp;</a></span>criteria</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::criteria</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The criteria parameter is used to set the criteria by which the cell data will be evaluated. For example in the expression <code>a &gt; 5 the criteria is</code>&gt;` or, in libxlsxwriter terms, <a class="el" href="worksheet_8h.html#a47b554f3a8f1475b57df705fd326ae6ba10ffa392949de59161307149c55a971b">LXW_CONDITIONAL_CRITERIA_GREATER_THAN</a>. The criteria that are applicable depend on the conditional format type. The criteria options are defined in <a class="el" href="worksheet_8h.html#a47b554f3a8f1475b57df705fd326ae6b" title="The criteria used in a conditional format.">lxw_conditional_criteria</a>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format1_8c-example.html#a13">conditional_format1.c</a>, and <a class="el" href="conditional_format2_8c-example.html#a14">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="aa11acc4f64d532fafc7cda9a98dc1fc9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa11acc4f64d532fafc7cda9a98dc1fc9">&#9670;&nbsp;</a></span>value</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">double lxw_conditional_format::value</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The number value to which the condition refers. For example in the expression <code>a &gt; 5</code>, the value is 5. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format1_8c-example.html#a15">conditional_format1.c</a>, and <a class="el" href="conditional_format2_8c-example.html#a16">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="ad09997b3e8aa12dba5617739c8839e7d"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad09997b3e8aa12dba5617739c8839e7d">&#9670;&nbsp;</a></span>value_string</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_conditional_format::value_string</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The string value to which the condition refers, such as <code>"=A1"</code>. If a value_string exists in the struct then the number value is ignored. Note, if the condition refers to a text string then it must be double quoted like this <code>"foo"</code>. </p>

</div>
</div>
<a id="a3d3ca3432272ee4d5172349ae030dfcc"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a3d3ca3432272ee4d5172349ae030dfcc">&#9670;&nbsp;</a></span>format</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="structlxw__format.html">lxw_format</a>* lxw_conditional_format::format</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The format field is used to specify the <a class="el" href="structlxw__format.html" title="Struct to represent the formatting properties of an Excel format.">lxw_format</a> format that will be applied to the cell when the conditional formatting criterion is met. The <a class="el" href="structlxw__format.html" title="Struct to represent the formatting properties of an Excel format.">lxw_format</a> is created using the <code><a class="el" href="workbook_8h.html#a279a5d7075d09a3931aae9782afede33" title="Create a new Format object to formats cells in worksheets.">workbook_add_format()</a></code> method in the same way as cell formats.</p>
<dl class="section note"><dt>Note</dt><dd>In Excel, a conditional format is superimposed over the existing cell format and not all cell format properties can be modified. Properties that <b>cannot</b> be modified, in Excel, by a conditional format are: font name, font size, superscript and subscript, diagonal borders, all alignment properties and all protection properties. </dd></dl>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format1_8c-example.html#a16">conditional_format1.c</a>, and <a class="el" href="conditional_format2_8c-example.html#a17">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="af8b4013a50ba2a58fa009dc22dcb9db8"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af8b4013a50ba2a58fa009dc22dcb9db8">&#9670;&nbsp;</a></span>min_value</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">double lxw_conditional_format::min_value</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The minimum value used for Cell, Color Scale and Data Bar conditional formats. For Cell types this is usually used with a "Between" style criteria. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a22">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a171ca24363807d7071d7044f9586a481"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a171ca24363807d7071d7044f9586a481">&#9670;&nbsp;</a></span>min_value_string</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_conditional_format::min_value_string</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The minimum string value used for Cell, Color Scale and Data Bar conditional formats. Usually used to set ranges like <code>=A1</code>. </p>

</div>
</div>
<a id="aedf2517dee1d1aac4e963dc315879b62"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aedf2517dee1d1aac4e963dc315879b62">&#9670;&nbsp;</a></span>min_rule_type</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::min_rule_type</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The rule used for the minimum condition in Color Scale and Data Bar conditional formats. The rule types are defined in <a class="el" href="worksheet_8h.html#aa1c8a0821648b21a1483d743587bb8eb" title="Conditional format rule types.">lxw_conditional_format_rule_types</a>. </p>

</div>
</div>
<a id="ab800fddf49071afb1ce9f020d44b2b3c"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ab800fddf49071afb1ce9f020d44b2b3c">&#9670;&nbsp;</a></span>min_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::min_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The color used for the minimum Color Scale conditional format. See <a class="el" href="working_with_colors.html">Working with Colors</a>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a34">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="ae05120a2be801d037bed0abe8a71de40"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ae05120a2be801d037bed0abe8a71de40">&#9670;&nbsp;</a></span>mid_value</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">double lxw_conditional_format::mid_value</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The middle value used for Color Scale and Data Bar conditional formats. <br  />
 </p>

</div>
</div>
<a id="ad0b7b11e7e88aeb9b92c24b1e7901cb8"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad0b7b11e7e88aeb9b92c24b1e7901cb8">&#9670;&nbsp;</a></span>mid_value_string</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_conditional_format::mid_value_string</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The middle string value used for Color Scale and Data Bar conditional formats. Usually used to set ranges like <code>=A1</code>. </p>

</div>
</div>
<a id="a0b3dd44b45e5cc5c49be1817aa873b04"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a0b3dd44b45e5cc5c49be1817aa873b04">&#9670;&nbsp;</a></span>mid_rule_type</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::mid_rule_type</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The rule used for the middle condition in Color Scale and Data Bar conditional formats. The rule types are defined in <a class="el" href="worksheet_8h.html#aa1c8a0821648b21a1483d743587bb8eb" title="Conditional format rule types.">lxw_conditional_format_rule_types</a>. </p>

</div>
</div>
<a id="af81689ba9f4c8a89b1e32f62054136ad"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af81689ba9f4c8a89b1e32f62054136ad">&#9670;&nbsp;</a></span>mid_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::mid_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The color used for the middle Color Scale conditional format. See <a class="el" href="working_with_colors.html">Working with Colors</a>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a37">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a18ce2238c9d2c51b79e9c9206c892a2c"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a18ce2238c9d2c51b79e9c9206c892a2c">&#9670;&nbsp;</a></span>max_value</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">double lxw_conditional_format::max_value</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The maximum value used for Cell, Color Scale and Data Bar conditional formats. For Cell types this is usually used with a "Between" style criteria. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a23">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="ade7850adeac45fc0ebc95b31bed939cf"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ade7850adeac45fc0ebc95b31bed939cf">&#9670;&nbsp;</a></span>max_value_string</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_conditional_format::max_value_string</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The maximum string value used for Cell, Color Scale and Data Bar conditional formats. Usually used to set ranges like <code>=A1</code>. </p>

</div>
</div>
<a id="af473b5134c8851ad6e8e32b8e96e125a"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af473b5134c8851ad6e8e32b8e96e125a">&#9670;&nbsp;</a></span>max_rule_type</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::max_rule_type</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The rule used for the maximum condition in Color Scale and Data Bar conditional formats. The rule types are defined in <a class="el" href="worksheet_8h.html#aa1c8a0821648b21a1483d743587bb8eb" title="Conditional format rule types.">lxw_conditional_format_rule_types</a>. </p>

</div>
</div>
<a id="a6d4a5eb20238f46f2fc594f1a5e1bc33"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a6d4a5eb20238f46f2fc594f1a5e1bc33">&#9670;&nbsp;</a></span>max_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::max_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The color used for the maximum Color Scale conditional format. See <a class="el" href="working_with_colors.html">Working with Colors</a>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a35">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="ad2dc53f2c1668c926452a27b41fcb640"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad2dc53f2c1668c926452a27b41fcb640">&#9670;&nbsp;</a></span>bar_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::bar_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_color field sets the fill color for data bars. See <a class="el" href="working_with_colors.html">Working with Colors</a>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a41">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a208a4c91723db5794041d1b488992619"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a208a4c91723db5794041d1b488992619">&#9670;&nbsp;</a></span>bar_only</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::bar_only</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_only field sets The bar_only field displays a bar data but not the data in the cells. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a39">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a407c47249bff85bdc92f25502daea813"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a407c47249bff85bdc92f25502daea813">&#9670;&nbsp;</a></span>data_bar_2010</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::data_bar_2010</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>In Excel 2010 additional data bar properties were added such as solid (non-gradient) bars and control over how negative values are displayed. These properties can shown below.</p>
<p>The data_bar_2010 field sets Excel 2010 style data bars even when Excel 2010 specific properties aren't used. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a45">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a7f3f95a74f02ab316c38db46b0b8499c"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a7f3f95a74f02ab316c38db46b0b8499c">&#9670;&nbsp;</a></span>bar_solid</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::bar_solid</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_solid field turns on a solid (non-gradient) fill for data bars. Set to LXW_TRUE to turn on. Excel 2010 only. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a42">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a1f9a9a9a1840d78f6ac697365bb957bf"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a1f9a9a9a1840d78f6ac697365bb957bf">&#9670;&nbsp;</a></span>bar_negative_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::bar_negative_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_negative_color field sets the color fill for the negative portion of a data bar. See <a class="el" href="working_with_colors.html">Working with Colors</a>. Excel 2010 only. </p>

</div>
</div>
<a id="afbf602ea1d3d6df8591976c9c62a7cf9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#afbf602ea1d3d6df8591976c9c62a7cf9">&#9670;&nbsp;</a></span>bar_border_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::bar_border_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_border_color field sets the color for the border line of a data bar. See <a class="el" href="working_with_colors.html">Working with Colors</a>. Excel 2010 only. </p>

</div>
</div>
<a id="a1ee05313ff7e57c5ac48aca6b0ed3034"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a1ee05313ff7e57c5ac48aca6b0ed3034">&#9670;&nbsp;</a></span>bar_negative_border_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::bar_negative_border_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_negative_border_color field sets the color for the border of the negative portion of a data bar. See <a class="el" href="working_with_colors.html">Working with Colors</a>. Excel 2010 only. </p>

</div>
</div>
<a id="aa78aa5551b20f92d1d80efc00939005c"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa78aa5551b20f92d1d80efc00939005c">&#9670;&nbsp;</a></span>bar_negative_color_same</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::bar_negative_color_same</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_negative_color_same field sets the fill color for the negative portion of a data bar to be the same as the fill color for the positive portion of the data bar. Set to LXW_TRUE to turn on. Excel 2010 only. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a46">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="ad053eb830063113c9893c04a0a7b4ef4"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad053eb830063113c9893c04a0a7b4ef4">&#9670;&nbsp;</a></span>bar_negative_border_color_same</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::bar_negative_border_color_same</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_negative_border_color_same field sets the border color for the negative portion of a data bar to be the same as the border color for the positive portion of the data bar. Set to LXW_TRUE to turn on. Excel 2010 only. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a47">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="addb516a5e4872c4dfaafe1718dc9a8a9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#addb516a5e4872c4dfaafe1718dc9a8a9">&#9670;&nbsp;</a></span>bar_no_border</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::bar_no_border</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_no_border field turns off the border for data bars. Set to LXW_TRUE to enable. Excel 2010 only. </p>

</div>
</div>
<a id="a8b249e7f9e9f4849013e1879d9629eb1"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a8b249e7f9e9f4849013e1879d9629eb1">&#9670;&nbsp;</a></span>bar_direction</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::bar_direction</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_direction field sets the direction for data bars. This property can be either left for left-to-right or right for right-to-left. If the property isn't set then Excel will adjust the position automatically based on the context. Should be a <a class="el" href="worksheet_8h.html#a3d18ac39694d2ee9256b17e74d1f9168" title="Conditional format data bar directions.">lxw_conditional_format_bar_direction</a> value. Excel 2010 only. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a43">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a4082b4c5f5d63cc22b2aca1e0f482648"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a4082b4c5f5d63cc22b2aca1e0f482648">&#9670;&nbsp;</a></span>bar_axis_position</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::bar_axis_position</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_axis_position field sets the position within the cells for the axis that is shown in data bars when there are negative values to display. The property can be either middle or none. If the property isn't set then Excel will position the axis based on the range of positive and negative values. Should be a lxw_conditional_bar_axis_position value. Excel 2010 only. </p>

</div>
</div>
<a id="acabc9974b1c8ae033909b3e634016e57"></a>
<h2 class="memtitle"><span class="permalink"><a href="#acabc9974b1c8ae033909b3e634016e57">&#9670;&nbsp;</a></span>bar_axis_color</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> lxw_conditional_format::bar_axis_color</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The bar_axis_color field sets the color for the axis that is shown in data bars when there are negative values to display. See <a class="el" href="working_with_colors.html">Working with Colors</a>. Excel 2010 only. </p>

</div>
</div>
<a id="a0cf9351bf7eb8bdfddb988ca9c24f308"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a0cf9351bf7eb8bdfddb988ca9c24f308">&#9670;&nbsp;</a></span>icon_style</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::icon_style</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The Icons Sets style is specified by the icon_style parameter. Should be a <a class="el" href="worksheet_8h.html#aaeb0374167b23080c63eccac2a64840b" title="Icon types used in the lxw_conditional_format icon_style field.">lxw_conditional_icon_types</a>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a49">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="aac7b01a937ca3203030ddbe8d34d54de"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aac7b01a937ca3203030ddbe8d34d54de">&#9670;&nbsp;</a></span>reverse_icons</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::reverse_icons</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The order of Icon Sets icons can be reversed by setting reverse_icons to LXW_TRUE. <br  />
 </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a51">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="ae7dce71531b0b265f88577b008368d96"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ae7dce71531b0b265f88577b008368d96">&#9670;&nbsp;</a></span>icons_only</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::icons_only</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The icons can be displayed without the cell value by settings the icons_only parameter to LXW_TRUE. <br  />
 </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a52">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a3fed811ec39cfda41a3c4db3135f1841"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a3fed811ec39cfda41a3c4db3135f1841">&#9670;&nbsp;</a></span>multi_range</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_conditional_format::multi_range</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The multi_range field is used to extend a conditional format over non-contiguous ranges.</p>
<p>It is possible to apply the conditional format to different cell ranges in a worksheet using multiple calls to <code>worksheet_conditional_format()</code>. However, as a minor optimization it is also possible in Excel to apply the same conditional format to different non-contiguous cell ranges.</p>
<p>This is replicated in <code>worksheet_conditional_format()</code> using the multi_range option. The range must contain the primary range for the conditional format and any others separated by spaces. For example <code>"A1 C1:C5 E2 G1:G100"</code>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="conditional_format2_8c-example.html#a32">conditional_format2.c</a>.</dd>
</dl>

</div>
</div>
<a id="a18603b91945774c02a3aeae8e133bbc6"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a18603b91945774c02a3aeae8e133bbc6">&#9670;&nbsp;</a></span>stop_if_true</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_conditional_format::stop_if_true</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The stop_if_true parameter can be used to set the "stop if true" feature of a conditional formatting rule when more than one rule is applied to a cell or a range of cells. When this parameter is set then subsequent rules are not evaluated if the current rule is true. Set to LXW_TRUE to turn on. </p>

</div>
</div>
</div><!-- contents -->
<!-- HTML footer for doxygen 1.8.20-->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Copyright 2014-2020 John McNamara.
Generated by&#160;<a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20
</small></address>
</body>
</html>
